Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- How do you use Trip Notes

Home Register
Log In
By How do you use Trip Notes
NYMike
3/7/2022
7:49:22 AM
How do you guys use trip notes?

I work off UDMs and the HTML report and rarely look at PP's which seems to be the only place they show up. I was hoping to be able to run a report of trip notes for the day's card to see if anything sticks out.

Thanks,

Mike

Reply
jeff
3/11/2022
12:19:38 PM
After populating the StartersToday table by running a SQL Calc Races, you could bring up the JCX File Exports Module and execute a sql expression that uses INNER JOIN STARTERSTODAY ON TripNotes.HORSENAME = STARTERSTODAY.HORSENAME to generate a list of horses running today that have TripNotes entries recorded in the TripNotes table.

Link to a thread from May, 2021 where I posted a working sql expression:
http://www.jcapper.com/MessageBoard/TopicReader.asp?topic=2343&forum=JCapper%20101



-jp

.




~Edited by: jeff  on:  3/11/2022  at:  12:19:38 PM~

Reply
Reply

Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com